﻿CREATE PROCEDURE [dbo].[proc_MarketProject_Update](
	@id INT,
	@T1 INT,
	@T2 INT,
	@BeginDate DATETIME,
	@EndDate DATETIME,
	@CityAddress NVARCHAR(100),
	@BorrowingAmount DECIMAL(18,2),
	@Account DECIMAL(18,2),
	@Profits DECIMAL(18,2),
	@EditDate DATETIME,
	@flag INT,
	@USERID VARCHAR(50),
	@DWBH INT,
	@BMBH VARCHAR(50)
)
AS
BEGIN

UPDATE [MarketProject]
   SET [T1] = @T1
      ,[T2] = @T2
      ,[BeginDate] = @BeginDate
      ,[EndDate] = @EndDate
      ,[CityAddress] = @CityAddress
      ,[BorrowingAmount] = @BorrowingAmount
      ,[Account] = @Account
      ,[Profits] = @Profits
      ,[EditDate] = @EditDate
      ,[flag] = @flag
      ,[USERID] = @USERID
      ,[DWBH] = @DWBH
      ,[BMBH] = @BMBH
 WHERE [id]=@id


	SET NOCOUNT ON;

END
